Easy2Siksha.com
GNDU Question Paper-2024
BBA 1
st
Semester
Computer Applications for Business
Time Allowed: Three Hours Max. Marks: 50
Note: Attempt Five questions in all, selecting at least One question from each section. The Fifth
question may be attempted from any section. All questions carry equal marks.
SECTION-A
1. What is Computer? Which are different types of Computers? Which are various
components of a computer?
2. Explain any two Output Devices.
SECTION-B
3. Write the features of DOS. Which are differences between Internal and External
commands of DOS? Explain any two commands of each type.
4. Which are various functions performed by OS? Which are various OS based on their
working?
SECTION-C
5. What is meaning and use of Importing, Exporting and Inserting files in MS-Word?
6. Explain the following as used in MS-Word:
Easy2Siksha.com
(a) Bookmark.
(b) Find & Replace.
(c) Margins.
SECTION-D
7. What is difference between function and formula? Explain any five inbuilt functions of
MS-Excel.
8. How a presentation software like MS-PowerPoint is useful for a student?
GNDU Answer Paper-2024
BBA 1
st
Semester
Computer Applications for Business
Time Allowed: Three Hours Max. Marks: 50
Note: Attempt Five questions in all, selecting at least One question from each section. The Fifth
question may be attempted from any section. All questions carry equal marks.
SECTION-A
1. What is Computer? Which are different types of Computers? Which are various
components of a computer?
Ans: Understanding Computers: A Journey into the Digital World
Imagine waking up one morning to find your daily life completely disconnected from
technology. No phone to check messages, no laptop to attend online classes, no ATM to
withdraw money, no traffic lights coordinating the city roads—life would suddenly feel
chaotic. Behind the smooth functioning of all these activities is a silent hero: the computer.
Easy2Siksha.com
But what exactly is a computer? How many kinds of computers exist, and what makes them
tick? Let’s unravel this story step by step, as if we are exploring a fascinating machine world
together.
What is a Computer?
A computer is much more than a box with wires, chips, and a screen. At its heart, a
computer is an electronic device that takes input, processes it according to instructions,
stores data, and produces output. In simpler words, it is a machine that helps us perform
tasks quickly and accurately, tasks that would otherwise take hours, days, or even years if
done manually.
Think of a computer as a magical helper that listens to your instructions (input), thinks
through them very fast (processing), remembers important details (storage), and finally
shows you results (output). Whether it’s calculating your math homework, designing a
building, editing videos, or booking a train ticket, the computer silently works behind the
scenes.
Some essential characteristics of a computer include:
• Speed: A computer can process millions of instructions in a second.
• Accuracy: When given correct instructions, a computer never makes mistakes.
• Storage: Computers can store vast amounts of data for future use.
• Automation: Once programmed, computers can perform tasks automatically
without human intervention.
Different Types of Computers
Not all computers are the same. Depending on size, capability, and usage, computers are
classified into several types. Let’s explore them in an easy, story-like manner.
1. Supercomputers
Imagine a giant brain that can solve problems faster than any human mind. That’s a
supercomputer! These are the fastest computers and are used for highly complex
tasks, like predicting weather patterns, simulating space missions, or researching
nuclear energy. For example, India’s Param Supercomputer is used in scientific
research and defense.
2. Mainframe Computers
Mainframes are the giants of the office world. They are huge computers that handle
enormous amounts of data simultaneously. Think of a bank or railway reservation
system—they rely on mainframes to manage millions of transactions every day.
Mainframes are powerful but stationary—they don’t sit on your desk.
3. Minicomputers
Minicomputers are smaller than mainframes but still powerful. They are like the
Easy2Siksha.com
“middle class” of computers, serving organizations that need good processing power
but don’t require a giant machine. Universities, hospitals, and medium-sized
industries often use minicomputers.
4. Microcomputers / Personal Computers (PCs)
Microcomputers are what we usually call PCs, laptops, or desktops. They are small,
affordable, and designed for individual use. Students, professionals, and even
gamers use them daily. A laptop in your backpack or a desktop in your study room is
a microcomputer.
5. Workstations
Workstations are specialized personal computers designed for tasks requiring higher
performance, like 3D modeling, animation, and scientific simulations. They are faster
than ordinary PCs and often come with advanced graphics and memory.
6. Embedded Computers
Embedded computers are hidden heroes. They are small computers placed inside
machines or devices to perform specific functions. For example, washing machines,
microwave ovens, cars, and traffic lights have embedded computers controlling their
operations. You might not see them, but they make modern devices smart.
Components of a Computer
Now, let’s dive inside the computer and explore its components. Imagine opening a treasure
chest and discovering all the tools that make the computer work. Components can be
broadly divided into hardware (the physical parts) and software (the programs and
instructions). Here, we focus on the hardware, the backbone of every computer.
1. Input Devices
Input devices are like the eyes, ears, and hands of a computer. They allow users to
communicate with the machine. Common examples include:
• Keyboard: For typing text and commands.
• Mouse: For pointing, clicking, and navigating.
• Scanner: For converting physical documents into digital form.
• Microphone: For capturing sound.
Think of them as the bridge between humans and the digital world.
2. Central Processing Unit (CPU)
The CPU is the brain of the computer. It processes instructions received from input devices
and software. The CPU has two main parts:
• Arithmetic Logic Unit (ALU): Performs calculations and logical operations.
• Control Unit (CU): Directs all operations in the computer and ensures everything
works in harmony.
Easy2Siksha.com
Without the CPU, a computer would be like a body without a brain—alive but unable to
think.
3. Memory / Storage
Memory allows computers to store and retrieve data. It can be classified into:
• Primary Memory (RAM): Temporary memory used while the computer is running.
It’s fast but loses data when the power is off.
• Secondary Memory (Hard Disk, SSD): Permanent storage for files, programs, and
data. Think of it as the computer’s diary.
There are also cache memory and ROM, but RAM and hard drives are the most common
ones.
4. Output Devices
Output devices display or produce the results of computer processing. Examples include:
• Monitor: Shows visual output.
• Printer: Produces physical copies of documents.
• Speakers: Produce sound.
If input devices feed the brain, output devices show the results of its thinking.
5. Motherboard
The motherboard is the heart of the computer where all components are connected. It
allows communication between CPU, memory, storage, and peripheral devices. Think of it
as the central hub of a city where all roads meet.
6. Power Supply
Every computer needs energy. The power supply converts electricity from the wall socket
into a form usable by computer components. Without it, nothing would function.
Diagram of Computer Components
Here’s a simple diagram to visualize the parts of a computer:
Easy2Siksha.com
Conclusion
A computer is not just a machine—it is a companion in our modern world. From humble
microcomputers in homes to powerful supercomputers predicting the weather, computers
have transformed every aspect of life. Understanding its types and components helps us
appreciate the incredible technology that powers our daily routines.
The next time you type an assignment, scroll through social media, or watch a movie on a
laptop, remember the journey of the input, CPU, memory, and output devices working
together seamlessly. Computers are not magic—they are a beautiful symphony of science,
engineering, and human ingenuity.
2. Explain any two Output Devices.
Ans: It’s late evening. Aarav, a school student, has just finished typing his science project on
the computer. He clicks “Print,” and within seconds, a crisp sheet of paper slides out of the
printer with his neatly formatted project report. Later, he relaxes by watching a video on the
monitor, where bright images and text appear as if the computer is speaking directly to him.
What Aarav experienced are the wonders of output devices—the parts of a computer that
take invisible digital data and transform it into something we can see, touch, or hear.
Without output devices, computers would remain silent boxes, full of information but
unable to communicate with us.
In this note, we will explain two of the most important output devices—Monitor and
Printer—in a simple, story-like way, covering their meaning, working, types, importance,
and even diagrams.
Easy2Siksha.com
What Are Output Devices?
An output device is any hardware component that takes processed data from the computer
and presents it in a form understandable to humans—whether as text, images, sound, or
physical copies.
• Input devices (like keyboard, mouse) send data into the computer.
• Output devices bring results out of the computer.
Now let’s dive into our two chosen devices.
Part (a): Monitor – The Computer’s Face
Meaning
A monitor is the most common output device. It displays text, images, videos, and graphics
on a screen. It is often called the Visual Display Unit (VDU) because it shows the “face” of
the computer’s work.
How It Works
• The computer’s graphics card sends signals to the monitor.
• The monitor converts these signals into tiny dots called pixels.
• Millions of pixels light up in different colors to form images and text.
Types of Monitors
1. CRT (Cathode Ray Tube): Old bulky monitors, like old TVs.
2. LCD (Liquid Crystal Display): Slim, energy-efficient, widely used.
3. LED (Light Emitting Diode): Advanced LCD with LED backlighting, sharper and
brighter.
4. TFT (Thin Film Transistor): High-quality displays used in laptops.
5. Touchscreen Monitors: Act as both input and output devices.
Importance of Monitors
• Without a monitor, we cannot see what the computer is doing.
• Essential for education, entertainment, design, gaming, and office work.
• Provides soft copy output (temporary, visible on screen).
Example: Aarav watching his project presentation on the monitor before printing it.
Part (b): Printer – The Computer’s Voice on Paper
Meaning
Easy2Siksha.com
A printer is an output device that transfers digital text and images onto paper, producing a
hard copy. It allows us to hold the computer’s work in our hands.
How It Works
• The computer sends print commands to the printer.
• The printer processes the data and applies ink/toner onto paper.
• The result is a permanent, physical copy of the digital file.
Types of Printers
1. Dot Matrix Printer:
o Uses pins to strike an ink ribbon.
o Produces low-quality prints, but cheap and durable.
2. Inkjet Printer:
o Sprays tiny droplets of liquid ink onto paper.
o Produces high-quality, colorful prints.
3. Laser Printer:
o Uses laser beams and toner powder.
o Fast, efficient, and best for bulk printing.
4. 3D Printer (Modern):
o Creates three-dimensional objects layer by layer.
o Used in medicine, engineering, and design.
Importance of Printers
• Provide permanent records of documents.
• Essential for schools, offices, banks, and government work.
• Useful for reports, assignments, bills, tickets, and designs.
Example: Aarav’s project report printed neatly for submission.
Comparison Between Monitor and Printer
Feature
Monitor (VDU)
Printer
Output Type
Soft copy (temporary)
Hard copy (permanent)
Medium
Screen (pixels)
Paper (ink/toner)
Use
Viewing, editing, entertainment
Records, reports, official documents
Example
Watching a video
Printing a project report
Why These Devices Matter
• Monitor: Acts like the eyes of the computer, showing us everything instantly.
• Printer: Acts like the hands of the computer, giving us something tangible to hold.
Together, they make the computer’s work visible and useful in both digital and physical
worlds.
Easy2Siksha.com
Conclusion
Output devices are the bridge between humans and computers. Among them, the monitor
and printer are the most essential. The monitor gives us a soft copy view of the computer’s
work, while the printer provides a hard copy we can carry, file, or submit.
Think again of Aarav: without his monitor, he couldn’t see or edit his project; without his
printer, he couldn’t submit it to his teacher. Both devices worked together to make his
effort complete.
Thus, output devices are not just technical tools—they are storytellers, translating the silent
language of computers into forms we can see, touch, and use in our daily lives.
SECTION-B
3. Write the features of DOS. Which are differences between Internal and External
commands of DOS? Explain any two commands of each type.
Ans: Exploring DOS: The Heartbeat of Early Computers
Imagine stepping into a computer lab in the 1980s. The air hums with anticipation, and the
only thing between you and the powerful microcomputer is a black screen with a blinking
cursor. There are no fancy icons, no colorful windows, and no mouse to click around. The
magic happens through commands typed on the keyboard. This is the world of DOS (Disk
Operating System), the operating system that acted like a bridge between humans and
computers before Windows and macOS became popular.
Let’s dive into the story of DOS and understand why it was so important, its features, and
how users communicated with it through commands.
Features of DOS
DOS was more than just a system to run programs—it was a carefully designed environment
that gave users control over their computer. Here are some of its key features:
1. Command-Line Interface (CLI): Unlike modern operating systems with graphical
interfaces, DOS was purely command-based. Users typed commands to manage files,
run programs, and control hardware. Think of it as giving spoken instructions to a
very obedient assistant—if you said it correctly, it would execute perfectly; if not, it
would return an error.
2. Single-Tasking System: DOS could run only one program at a time. Unlike today’s
multitasking systems, users had to finish one task before moving to another. Imagine
cooking a meal in a tiny kitchen with only one stove—efficient but requires planning.
Easy2Siksha.com
3. File Management: DOS introduced a structured way to store files using directories
and subdirectories, like a library with shelves and sections. Users could create,
delete, copy, and move files using commands like COPY or DEL.
4. Disk Management: DOS provided tools to manage storage devices, such as
formatting a disk or checking its content. This was crucial when computers relied
heavily on floppy disks, which were small, fragile, and required constant attention.
5. Booting and System Files: DOS could be loaded from a disk, and it used system files
like IO.SYS, MSDOS.SYS, and COMMAND.COM to start the computer. It made the
system self-contained and easy to transport—just insert the disk, and you were
ready to work.
6. Lightweight and Fast: Because DOS had no graphical elements, it used very little
memory, making it fast and efficient even on early computers with limited
resources.
7. Batch Processing: DOS allowed users to automate tasks using batch files (.BAT).
These were scripts that executed multiple commands in sequence, saving time and
effort. It was like leaving instructions for your assistant to follow while you went
away.
Internal vs External Commands of DOS
DOS commands are the language you use to communicate with the system. These
commands fall into two categories: internal and external. Understanding the difference is
crucial for effectively managing files and programs.
Feature
Internal Commands
External Commands
Definition
Commands stored in the computer’s
memory (COMMAND.COM) and
available immediately after booting.
Commands stored as separate files
on disk (e.g., .COM or .EXE) and
need to be loaded from the disk
when executed.
Availability
Always available after DOS starts.
Available only if the corresponding
program file exists on disk.
Execution
Speed
Faster because they are already in
memory.
Slightly slower because they must
be loaded from disk first.
Examples
DIR, COPY, DEL
FORMAT, XCOPY, CHKDSK
Examples of Internal Commands
Internal commands are the backbone of DOS. Let’s look at two important ones:
1. DIR (Directory Listing):
o Purpose: Shows the files and folders in the current directory.
o How it works: Type DIR and hit Enter. DOS will list all files with details like
name, size, and creation date.
Easy2Siksha.com
o Example in story terms: Imagine walking into a library and calling out, “Show
me all books on this shelf!” DOS obliges by listing every title neatly.
2. COPY:
o Purpose: Copies files from one location to another.
o How it works: Use COPY source destination. For example, COPY REPORT.TXT
D:\BACKUP\REPORT.TXT duplicates a file.
o Story analogy: Think of taking a handwritten note and making a photocopy to
keep in another drawer. DOS does the copying instantly.
Examples of External Commands
External commands expand DOS’s capabilities but require disk access:
1. FORMAT:
o Purpose: Prepares a disk for use by DOS. It erases all data and sets up a new
file system.
o Example: FORMAT A: formats the floppy disk in drive A.
o Story analogy: Imagine clearing an old notebook completely before starting a
new set of notes—fresh pages ready for writing.
2. XCOPY:
o Purpose: Copies entire directories along with subdirectories, more powerful
than COPY.
o Example: XCOPY C:\PROJECT D:\BACKUP /S copies the whole PROJECT folder
to a backup location.
o Story analogy: It’s like moving an entire shelf of books, including all the
sections within it, instead of moving one book at a time.
How Internal and External Commands Work Together
To really appreciate DOS, consider a scenario: you want to back up your important files to a
floppy disk.
1. Use DIR to check what files exist in your project folder.
2. Use COPY to duplicate key files to a new location.
3. Use FORMAT to prepare the floppy disk for backup.
4. Use XCOPY to move the entire project, including subfolders, to the floppy.
Without internal commands, you couldn’t quickly examine or copy files. Without external
commands, you couldn’t format a disk or move complex directories. Together, they made
DOS a flexible, reliable system.
Easy2Siksha.com
Diagram: Internal vs External Commands
Here’s a simple conceptual diagram:
Conclusion
DOS may seem old-fashioned today, but its simplicity and power shaped the way we
interact with computers. Its features—command-line interface, file and disk management,
batch processing—made it the heart of early computing. The distinction between internal
and external commands shows how DOS balanced speed and functionality: some
commands were always ready in memory, while others could be loaded from disk as
needed.
By understanding commands like DIR, COPY, FORMAT, and XCOPY, students not only learn
the practical side of DOS but also develop an appreciation for how early programmers
solved problems with limited resources. DOS teaches patience, precision, and creativity—
the same qualities that modern computing still relies on.
Even today, when we use graphical interfaces, the philosophy of DOS lives on in the
command prompts, scripts, and terminal windows that run silently in the background,
reminding us of the era when humans and machines communicated through typed words,
one command at a time.
4. Which are various functions performed by OS? Which are various OS based on their
working?
Ans: Think of a grand orchestra. There are dozens of musicians—each with their own
instrument—violins, flutes, drums, trumpets. If everyone plays at once without
coordination, the result is chaos. But when a conductor steps in, guiding who plays when
and how, the same group produces beautiful music.
In the world of computers, the Operating System (OS) is that conductor. It doesn’t play the
instruments (applications) itself, but it ensures that every part of the computer—CPU,
Easy2Siksha.com
memory, input/output devices—works in harmony. Without the OS, the computer would be
like an orchestra without a conductor: noisy, confusing, and unproductive.
Now, let’s explore the functions performed by an OS and the different types of OS based
on their working, in a way that feels like a story unfolding.
Functions of an Operating System
The OS performs many crucial tasks, but they can be grouped into a few key functions.
1. Process Management
• A process is simply a running program.
• The OS decides which process gets the CPU, for how long, and in what order.
• It uses scheduling algorithms (like Round Robin, Priority Scheduling) to ensure
fairness and efficiency.
• It also handles synchronization (making sure processes don’t clash when using
shared resources) and deadlock prevention (avoiding situations where processes
wait forever).
Example: When you listen to music while browsing the internet, the OS ensures both
apps get CPU time without crashing.
2. Memory Management
• The OS keeps track of which part of memory is being used and by which process.
• It allocates memory when a program starts and deallocates it when the program
ends.
• It also uses techniques like paging and segmentation to optimize memory use.
Example: When you open multiple browser tabs, the OS ensures each tab gets its own
memory space.
3. File Management
• The OS manages files on storage devices.
• It organizes data into directories and provides operations like create, read, write,
and delete.
• It also controls access permissions to ensure security.
Example: When you save a Word document, the OS decides where on the hard disk it
will be stored and how it can be retrieved later.
4. Device Management
• Computers have many devices: keyboard, mouse, printer, hard disk, etc.
• The OS acts as a mediator between hardware and software using device drivers.
Easy2Siksha.com
• It ensures smooth input/output operations.
Example: When you click “Print,” the OS translates that command into instructions the
printer understands.
5. Security and Access Control
• The OS protects data and resources from unauthorized access.
• It uses passwords, encryption, and permissions to safeguard the system.
Example: When you log into your laptop with a password, the OS verifies your identity
before granting access.
6. User Interface
• The OS provides a way for users to interact with the computer.
• This can be Command-Line Interface (CLI) (like MS-DOS) or Graphical User Interface
(GUI) (like Windows, macOS).
Example: Clicking icons on your desktop is possible because of the OS’s GUI.
7. Networking and Communication
• The OS manages network connections, enabling computers to communicate.
• It handles data transfer, error detection, and resource sharing.
Example: When you send an email, the OS ensures your data packet travels safely across
the internet.
8. Error Detection and Handling
• The OS constantly monitors the system for errors.
• It provides alerts and takes corrective actions.
Example: When an application crashes, the OS shows a message like “This program is
not responding.”
Diagram: Functions of OS
Easy2Siksha.com
Types of Operating Systems (Based on Working)
Operating systems can be classified into different types depending on how they manage
tasks and resources.
1. Batch Operating System
• Jobs are collected in batches and executed one after another without user
interaction.
• Common in early computers.
Example: Payroll processing in the 1960s.
2. Time-Sharing (Multitasking) OS
• Allows multiple users/programs to share CPU time simultaneously.
• Each task gets a small time slice.
Example: Modern Windows, Linux, macOS.
3. Multiprocessing OS
• Uses multiple CPUs to execute tasks in parallel.
• Increases speed and reliability.
Example: High-performance servers.
4. Real-Time OS (RTOS)
• Responds to inputs instantly, with minimal delay.
• Used in systems where timing is critical.
Example: Air traffic control, medical equipment, space missions.
Easy2Siksha.com
5. Distributed OS
• Manages a group of independent computers and makes them appear as a single
system.
• Provides resource sharing and faster computation.
Example: Google’s distributed systems.
6. Network OS
• Provides services to computers connected in a network.
• Manages file sharing, printer access, and communication.
Example: Novell NetWare, Windows Server.
7. Mobile OS
• Designed for smartphones and tablets.
• Optimized for touch input and mobile hardware.
Example: Android, iOS.
Critical Insights
• No single OS type is “best”—each is designed for specific needs.
• A real-time OS is perfect for a rocket launch, but not for your laptop.
• A mobile OS is great for touchscreens, but not for supercomputers.
Conclusion
The Operating System is the unsung hero of computing. Like a conductor in an orchestra, it
ensures harmony between hardware and software, managing processes, memory, files,
devices, and security. Without it, computers would be lifeless machines.
At the same time, different types of OS—batch, time-sharing, multiprocessing, real-time,
distributed, network, and mobile—show us how flexible and powerful this “conductor” can
be, adapting to everything from smartphones to satellites.
So, the next time you open your laptop or unlock your phone, remember: behind that
simple click or swipe, the OS is working tirelessly, orchestrating millions of operations every
second to make your digital life smooth and efficient.
Easy2Siksha.com
SECTION-C
5. What is meaning and use of Importing, Exporting and Inserting files in MS-Word?
Ans: Importing, Exporting, and Inserting Files in MS-Word: A Story of Sharing Knowledge
Imagine you are an author sitting at your desk, creating the next big novel. You have ideas
scattered across different notebooks, emails, and even presentations. Some are on your
laptop, others in PDFs or Excel sheets, and a few you even wrote on your tablet during a
trip. Now, your task is to compile all this into a single, beautifully formatted MS-Word
document. How do you do it efficiently? This is where the concepts of importing, exporting,
and inserting files in MS-Word come into play. These features are not just technical tools—
they are like bridges that allow your ideas to flow smoothly from one format or document
to another.
Let’s explore them one by one.
1. Importing Files in MS-Word
Meaning:
To import a file means to bring content from another file or format into your current MS-
Word document. You are essentially telling Word: “Hey, here is some content from outside—
let’s bring it in and make it part of my document.”
Use and Importance:
Imagine you received a colleague’s report in a PDF or an old Word document from last year.
You don’t want to rewrite everything from scratch. By importing, you can bring that content
directly into your current document. This saves time, maintains accuracy, and ensures
consistency.
• You can import text files (.txt), other Word documents (.docx), PDFs, and
sometimes even web pages.
• MS-Word automatically adapts the imported content to the current document’s
format.
Example Story:
Suppose you are preparing a research paper on climate change. You have a PDF containing
recent statistics. Instead of copying each number manually, you import the PDF into Word.
Suddenly, all the crucial data appears in your document, ready to be edited and formatted.
Step-by-Step Process:
1. Open MS-Word.
2. Click on File → Open → Browse and select the file you want to import.
3. Choose the format if necessary (like PDF).
Easy2Siksha.com
4. The content appears in your Word document, ready for editing.
2. Exporting Files in MS-Word
Meaning:
To export a file means to save your Word document in a different format or location so it
can be shared, printed, or used by another program. In simple words, exporting is like
packing your document in a suitcase that others can carry and open.
Use and Importance:
Exporting is important because not everyone uses Word. You might need to send your
document as a PDF, an XPS, or even a web page. Exporting ensures your formatting stays
intact, and anyone can view it exactly as you designed it.
• Common export formats include PDF (for secure sharing), Word 97-2003 (for older
computers), XPS, and HTML.
• Exporting is widely used in offices, schools, and publishing, where documents need
to be universally accessible.
Example Story:
Imagine you wrote an important project report. Your boss needs to review it on their phone,
but they don’t have MS-Word. You export it as a PDF, attach it to an email, and now your
boss can read it without worrying about fonts or layouts changing.
Step-by-Step Process:
1. Open your Word document.
2. Click File → Export → Create PDF/XPS Document.
3. Choose the location and file type.
4. Click Publish.
5. Your Word document is now exported and ready for sharing.
3. Inserting Files in MS-Word
Meaning:
To insert a file means to embed content from another file directly into your current Word
document without making it a separate document. Unlike importing, where the file
becomes part of the Word environment and may adapt to formatting, inserting keeps it as a
distinct object.
Use and Importance:
Inserting files is like adding ingredients to a recipe. You don’t mix everything together
immediately, but you place it where it belongs for easy reference.
Easy2Siksha.com
• You can insert Word documents, Excel sheets, PDFs, images, and even charts.
• Inserting is particularly useful when you want to reference data without changing its
original format.
Example Story:
Let’s say your supervisor asks you to prepare a project report with an Excel chart showing
sales data. Instead of copying the numbers, you insert the Excel file into Word. The chart
appears beautifully, and even if the original Excel sheet is updated, you can choose to link it
so your Word document reflects the changes.
Step-by-Step Process:
1. Open MS-Word.
2. Go to Insert → Object → Create from File → Browse.
3. Select the file you want to insert.
4. Optionally, check Link to file if you want updates in the original file to reflect in
Word.
5. Click OK, and the content appears in your document.
4. Key Differences Between Importing, Exporting, and Inserting
Feature
Importing
Exporting
Inserting
Purpose
Bring content from
another file
Save Word file in
another format
Embed another file into
Word
Result
Content becomes
editable in Word
Output file is
independent
File appears as an object
inside Word
Use
Case
Adding old reports,
PDFs, text
Sharing, printing,
universal access
Adding charts, images, or
references
Formats
PDF, TXT, DOCX, Web
PDF, XPS, DOC, HTML
DOCX, XLSX, PDF, Images
5. Practical Example: A Student’s Perspective
Imagine you are preparing a final year project report. Here’s how you might use these
features:
1. Importing: You have an old Word file of your introduction from last semester.
Instead of rewriting, you import it.
2. Inserting: Your experiment results are in an Excel sheet. You insert the sheet to show
dynamic charts inside your report.
3. Exporting: Once the report is ready, you export it as a PDF to submit it online or to
email your supervisor.
In this story, MS-Word acts like a magic notebook that allows you to collect, combine, and
share information effortlessly.
Easy2Siksha.com
6. Suggested Diagram for Easy Understanding
You can visualize the relationship like this:
• Import = Bringing content into Word.
• Insert = Embedding content inside Word as an object.
• Export = Sending content out of Word in another format.
7. Conclusion
The beauty of importing, exporting, and inserting in MS-Word is that they allow ideas to
travel across formats, systems, and people. They save time, prevent errors, and ensure that
knowledge flows seamlessly from one platform to another. By mastering these features,
students, professionals, and authors alike can work smarter, not harder.
In a world where information is everywhere—in PDFs, Excel sheets, emails, and older
documents—MS-Word’s importing, exporting, and inserting features are like bridges that
connect knowledge, making it accessible, editable, and shareable in one single place.
Understanding these features is not just about learning software; it’s about learning how to
organize, communicate, and present your ideas effectively, which is a skill that lasts a
lifetime.
6. Explain the following as used in MS-Word:
(a) Bookmark.
(b) Find & Replace.
(c) Margins.
Ans: Imagine you are writing a long novel in MS Word. It’s 200 pages long, full of characters,
twists, and subplots. You want to quickly jump back to Chapter 5 where a key event
happened, but scrolling endlessly feels like searching for a needle in a haystack. Later, you
realize you’ve spelled a character’s name “Rohan” in some places and “Rohit” in others—
Easy2Siksha.com
you need to fix this across the entire document. Finally, when you print your draft, you
notice the text is too close to the edges of the paper, making it look cramped.
What do you do?
This is where three powerful features of MS Word come to your rescue: Bookmarks, Find &
Replace, and Margins. They may sound simple, but together they make your document
organized, consistent, and professional. Let’s explore each one in detail, step by step, in a
way that feels like a story.
Part (a): Bookmark in MS Word
Meaning
A Bookmark in MS Word works just like a bookmark in a physical book. It marks a specific
location in your document so you can return to it instantly without scrolling.
Think of it as planting a flag in your document that says, “Remember this spot!”
How to Use a Bookmark
1. Place your cursor where you want the bookmark.
2. Go to the Insert tab → Bookmark (in the Links group).
3. Give your bookmark a name (no spaces allowed).
4. Click Add.
To return later:
• Go to Insert → Bookmark, select the name, and click Go To.
Example
Suppose you’re writing a research paper. You add a bookmark at the “Conclusion” section.
Later, instead of scrolling through 50 pages, you jump directly to the conclusion with one
click.
Importance of Bookmarks
• Saves time in long documents.
• Helps in editing and reviewing.
• Useful for cross-referencing sections.
Part (b): Find & Replace in MS Word
Meaning
Easy2Siksha.com
The Find & Replace feature is like having a personal detective and editor inside Word. It
helps you locate specific words or phrases and replace them with new ones—across the
entire document—in seconds.
Instead of manually scanning hundreds of pages, Word does the searching and
correcting for you.
How to Use Find & Replace
1. Press Ctrl + H (shortcut) or go to Home → Editing → Replace.
2. In the dialog box:
o Type the word you want to find in the Find what field.
o Type the replacement word in the Replace with field.
3. Choose:
o Find Next → to replace one by one.
o Replace All → to replace all at once.
Example
Imagine you typed “Rohan” 50 times in your novel but later decide the character’s name
should be “Arjun.” Instead of changing each one manually, you use Find & Replace. In
seconds, every “Rohan” becomes “Arjun.”
Advanced Options
• Match case (distinguish between “Word” and “word”).
• Whole words only.
• Replace formatting (e.g., change all bold text to italics).
Importance of Find & Replace
• Saves hours of manual editing.
• Ensures consistency in names, terms, or formatting.
• Essential for professional documents, reports, and books.
Part (c): Margins in MS Word
Meaning
Margins are the blank spaces around the edges of a page—top, bottom, left, and right. They
act like a frame for your text, making the document look neat and readable.
Without margins, text would run to the very edge of the paper, making it hard to read
and unprofessional.
How to Set Margins
Easy2Siksha.com
1. Go to the Layout tab → Margins.
2. Choose from presets: Normal, Narrow, Wide, etc.
3. Or select Custom Margins to set your own values.
Example
• For a school project, you might use Normal margins (1 inch on all sides).
• For a binding report, you might set a wider left margin to allow space for binding.
Diagram (Margins Concept)
Importance of Margins
• Improves readability.
• Provides space for notes, comments, or binding.
• Ensures documents look professional when printed.
Putting It All Together
Let’s return to Aarav’s novel story:
• He uses Bookmarks to jump between chapters quickly.
• He uses Find & Replace to correct his character’s name consistently.
• He adjusts Margins so the printed version looks neat and professional.
These three features, though simple, transform his messy draft into a polished manuscript
ready for submission.
Conclusion
MS Word is more than just a typing tool—it’s a powerful writing companion. Features like
Bookmarks, Find & Replace, and Margins may seem small, but they save time, reduce
errors, and make documents professional.
• Bookmark is your signpost in long documents.
• Find & Replace is your detective and editor.
Easy2Siksha.com
• Margins are the frame that makes your work look neat.
Together, they ensure that your writing is not only correct but also well-presented.
So, the next time you’re lost in a long document, remember: Word has already given you
the tools to find your way, fix your mistakes, and frame your masterpiece beautifully.
SECTION-D
7. What is difference between function and formula? Explain any five inbuilt functions of
MS-Excel.
Ans: Understanding Functions and Formulas in MS-Excel: A Story of Numbers
Imagine you are a chef in a busy kitchen. You have hundreds of ingredients at your disposal.
Some dishes you can prepare using simple recipes you already know, while others require
complicated steps, sometimes using tools and shortcuts. In the world of MS-Excel, formulas
and functions are like recipes in your kitchen. They help you turn raw numbers into
meaningful information—but each works in its own way.
Let’s explore this in detail.
Formula vs Function: What’s the Difference?
At first glance, formulas and functions might seem similar—they both perform calculations.
But think carefully: a formula is like a chef writing down their own recipe step by step. A
function, on the other hand, is like using a pre-made recipe or a ready-made spice mix. You
just follow it, and it works perfectly.
Here’s the distinction in simple terms:
Aspect
Formula
Function
Definition
A formula is a user-defined
calculation created by the user using
operators like +, -, *, /, etc.
A function is a predefined calculation
available in Excel to perform a
specific task.
Creation
Created manually by typing the
mathematical or logical expression.
Built-in; you only need to provide
arguments or inputs.
Ease of
Use
Requires understanding of arithmetic
or logical operations.
Easier to use; Excel does the complex
calculation internally.
Examples
=A1+B1 or =A2*10
=SUM(A1:A10) or =AVERAGE(B1:B10)
Flexibility
Highly flexible; you can create any
calculation.
Limited to the types of functions
provided by Excel.
Easy2Siksha.com
So, if you want to add two numbers, you can either create a formula =10+20, or you can use
the SUM function: =SUM(10,20). Both work, but the function saves time, especially when
dealing with large data.
Five Important Inbuilt Functions of MS-Excel
Now, imagine you are handling a huge dataset in Excel—maybe marks of 200 students, sales
figures of 1000 products, or expenses of a company for an entire year. Doing calculations
manually is impossible. That’s where inbuilt functions come to the rescue. Let’s look at five
commonly used Excel functions in a simple, story-like way.
1. SUM Function
Think of the SUM function as a magical basket that can hold numbers and give you the total
instantly.
• Syntax: =SUM(number1, number2, …)
• Example: =SUM(A1:A10) adds all values from A1 to A10.
• Use Case Story: Imagine you are a shopkeeper calculating total sales for a week.
Instead of adding each day’s sale individually, SUM adds them all at once. It’s like
having an invisible calculator working for you.
2. AVERAGE Function
Average is like finding the “middle path.” It tells you the typical or central value of a dataset.
• Syntax: =AVERAGE(number1, number2, …)
• Example: =AVERAGE(B1:B10) calculates the average marks of 10 students.
• Use Case Story: A teacher wants to know the average score of a class in Maths.
Instead of manually dividing the total by the number of students, AVERAGE does it
instantly—just like asking a wise old mentor for advice.
3. MAX Function
MAX is like a sports commentator shouting the name of the player with the highest score.
• Syntax: =MAX(number1, number2, …)
• Example: =MAX(C1:C20) finds the maximum value in a range.
Easy2Siksha.com
• Use Case Story: In a sales team, the manager wants to know the highest sale of the
month. Instead of scanning the entire list, MAX immediately points out the top
performer.
4. MIN Function
MIN is the opposite of MAX. It identifies the smallest value, like a detective spotting the
least expensive item in a market.
• Syntax: =MIN(number1, number2, …)
• Example: =MIN(D1:D15) gives the minimum number in a range.
• Use Case Story: Suppose a student wants to know which subject has the lowest
score to focus on improvement. MIN does this job effortlessly.
5. IF Function
The IF function is like a wise judge making decisions based on conditions. It checks whether
a condition is true or false, and then decides the outcome.
• Syntax: =IF(condition, value_if_true, value_if_false)
• Example: =IF(E1>=50,"Pass","Fail") checks if a student has scored 50 or more. If yes,
it returns “Pass”; otherwise, it returns “Fail.”
• Use Case Story: In a company, the HR wants to identify employees eligible for bonus
based on their performance. Instead of checking one by one, IF evaluates
automatically.
Diagram: Formula vs Function in Excel
You can visualize the difference as a simple diagram:
+---------------------+ +----------------------+
| FORMULA | | FUNCTION |
+---------------------+ +----------------------+
| User-defined | | Predefined in Excel |
| Calculation | | Task-specific |
| Example: =A1+B1 | | Example: =SUM(A1:A10)|
| Flexible but manual | | Easy & automatic |
+---------------------+ +----------------------+
Story Summary: Why Functions Make Excel Magical
Easy2Siksha.com
Imagine you are a wizard in a kingdom of numbers. With formulas, you have to mix your
potions carefully, step by step. One wrong ingredient, and your potion may fail. Functions,
however, are like magical spells—pre-cast, tested, and ready to use. Just give them your
ingredients (numbers or cells), and the spell works perfectly.
By learning to use functions like SUM, AVERAGE, MAX, MIN, and IF, you not only save time
but also reduce errors. You can handle thousands of numbers, track sales, calculate student
results, or analyze financial data—all with a few clicks.
In real life, Excel functions are everywhere—from accountants calculating taxes, teachers
checking grades, shopkeepers tracking sales, to managers preparing reports. Without them,
the world of numbers would be chaotic, just like a kitchen without recipes or tools.
Conclusion
In short, formulas are personal recipes you create, while functions are pre-designed, ready-
to-use recipes in Excel. Both are essential, but functions make life easier and more accurate.
Understanding and mastering them is like having a magic wand in the world of
spreadsheets—turning chaos into clarity, and raw data into meaningful decisions.
By combining formulas and functions, anyone—whether a student, teacher, manager, or
accountant—can make MS-Excel a powerful assistant, saving hours of work and avoiding
mistakes.
8. How a presentation software like MS-PowerPoint is useful for a student?
Ans: Picture a classroom where the teacher asks students to present their project on
“Climate Change.” One student walks up with a stack of handwritten notes and starts
reading in a flat voice. The audience quickly loses interest. Then another student walks in
with a laptop, connects it to the projector, and suddenly the screen lights up with colorful
slides—images of melting glaciers, graphs of rising temperatures, and short video clips of
floods. The same topic now feels alive, engaging, and memorable.
What made the difference? Presentation software like Microsoft PowerPoint.
For students, PowerPoint is not just a tool—it’s a stage, a storyteller, and a creative partner.
It transforms dull information into something visual, interactive, and impactful. Let’s explore
in detail how MS PowerPoint is useful for students, covering its features, benefits, and real-
life applications.
Easy2Siksha.com
What is MS PowerPoint?
Microsoft PowerPoint is a presentation software that allows users to create slideshows
combining text, images, charts, animations, audio, and video. It is part of the Microsoft
Office suite and is widely used in schools, colleges, and professional settings.
For students, it acts as a bridge between knowledge and communication—helping them
not only learn but also express their ideas effectively.
How MS PowerPoint is Useful for Students
1. Enhances Learning through Visuals
• Students can insert pictures, diagrams, and videos into slides.
• Visuals make complex topics easier to understand.
• Example: A biology student can show the human digestive system with labeled
diagrams instead of just describing it.
Visual learning improves memory retention and makes presentations more engaging.
2. Organizes Information Clearly
• PowerPoint forces students to break content into bullet points and slides.
• This prevents information overload and makes the presentation structured.
• Example: Instead of reading a 10-page essay, a student can summarize key points in
10 slides.
It teaches the skill of summarization and clarity.
3. Boosts Confidence in Public Speaking
• Having slides as a guide reduces nervousness.
• Students can use slides as prompts instead of memorizing everything.
• Example: During a seminar, a student can glance at the slide headings to stay on
track.
PowerPoint acts like a safety net for shy speakers.
4. Encourages Creativity
• Students can customize fonts, colors, backgrounds, and layouts.
• They can add animations, transitions, and multimedia.
• Example: A history project can include animated timelines and background music.
This nurtures creative expression alongside academic learning.
5. Supports Collaborative Learning
Easy2Siksha.com
• Multiple students can work on the same presentation.
• Cloud integration (OneDrive) allows group editing.
• Example: A group project on renewable energy can divide slides among members—
one for solar, one for wind, one for hydro.
Promotes teamwork and coordination.
6. Makes Revision Easier
• Slides act as quick revision notes before exams.
• Students can review key points in minutes instead of reading long chapters.
• Example: A student preparing for a viva can quickly go through their PowerPoint
slides.
PowerPoint doubles as a study aid.
7. Professional Skill Development
• PowerPoint is widely used in workplaces.
• Learning it early gives students an edge in careers.
• Example: Business students often present case studies using PowerPoint, preparing
them for corporate life.
It builds future-ready skills.
8. Interactive Learning with Hyperlinks and Multimedia
• Students can add hyperlinks to websites, videos, or other slides.
• This makes presentations interactive and dynamic.
• Example: A presentation on space exploration can include a link to NASA’s live
website.
Encourages exploration beyond textbooks.
9. Time-Saving and Efficient
• Templates and themes make slide creation quick.
• Copy-paste and drag-drop features save effort.
• Example: Instead of drawing charts by hand, students can insert ready-made graphs.
Saves time and increases productivity.
Diagram: Role of PowerPoint for Students
Easy2Siksha.com
Real-Life Examples
1. School Projects:
o Students present topics like “Water Conservation” with images, slogans, and
videos.
2. College Seminars:
o Engineering students use PowerPoint to explain technical diagrams.
3. Competitions:
o Debate and quiz teams use slides to display facts and statistics.
4. Online Learning:
o During virtual classes, PowerPoint slides are shared as study material.
Advantages of PowerPoint for Students
• Easy to use, even for beginners.
• Makes presentations attractive and professional.
• Encourages active participation in class.
• Improves communication and digital literacy.
Limitations (Critical View)
• Overuse of animations can distract.
• Students may rely too much on slides instead of understanding content.
• Requires access to a computer and projector.
Thus, PowerPoint is powerful, but it must be used wisely.
Easy2Siksha.com
Conclusion
Microsoft PowerPoint is more than just software—it is a learning companion for students. It
helps them learn better, present confidently, think creatively, and prepare for the future.
Think back to the classroom story: the student with handwritten notes struggled to hold
attention, while the one with PowerPoint captivated the audience. That’s the magic of
presentation software—it transforms knowledge into an experience.
For students, PowerPoint is not just about slides; it’s about telling stories, sharing ideas,
and leaving an impact.
“This paper has been carefully prepared for educational purposes. If you notice any mistakes or
have suggestions, feel free to share your feedback.”
